IF exists(SELECT * FROM dbo.sysobjects WHERE name='llnLagereSchool' AND xtype='V') 
BEGIN
	DROP VIEW llnLagereSchool
END
GO

CREATE view llnLagereSchool 
as
select l.voornaam + ' ' + l.achternaam as volleNaam,
	l.klas,l.klasNr,l.naam1,
	s.school,lagereSchool.lagereSchoolklas
from (leerlingen as l left join lagereSchool
   on l.inschrijvingsNr = lagereSchool.inschrijvingsNr)
	left join lijstLagereScholen as s
	on lagereSchool.lagereSchoolNummer = s.schoolNr